/**
 * 
 */
package com.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.entity.UserOauth;
import com.wcansoft.baseWeb.mybatis_plugin.dao.MybatisBaseDAO;
public interface UserOauthMapper  extends MybatisBaseDAO<UserOauth>{

	@Select("select * from user_oauth where uid=#{uid}")
	List<UserOauth> listUserOauth(Long uid);
	
	@Select("select * from user_oauth where oauth=#{oauth} and uid=#{uid}")
	List<UserOauth> getUserOauth(@Param("uid") Long uid,@Param("oauth")String oauth);
	
	@Select("select * from user_oauth where oauth=#{oauth} and openid=#{openid}")
	UserOauth getUserOauthByOpenIdAndOauth(@Param("openid") String openid,@Param("oauth") String oauth);
	


}
